from pyecharts import options as opts
from pyecharts.charts import Graph
import pandas as pd
df1=pd.read_excel('红楼梦部分人物关系.xlsx',sheet_name='sheet1')
list_nodes=df1.to_dict(orient='records')
print(list_nodes)
df2=pd.read_excel('红楼梦部分人物关系.xlsx',sheet_name='sheet2')
list_links=df2.to_dict(orient='records')
print(list_links)
df3=pd.read_excel('红楼梦部分人物关系.xlsx',sheet_name='sheet3')
list_categorys=df3.to_dict(orient='records')
print(list_categorys)